Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 6368 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.9 MiB |
| Average record size in memory | 316.7 B |
Variable types
| Text | 2 |
|---|---|
| Numeric | 11 |
| Categorical | 5 |
Age is highly overall correlated with km_driven and 3 other fields | High correlation |
RPM is highly overall correlated with torque (Nm) | High correlation |
engine is highly overall correlated with log_sell and 4 other fields | High correlation |
fuel is highly overall correlated with torque (Nm) | High correlation |
km_driven is highly overall correlated with Age and 1 other fields | High correlation |
log_sell is highly overall correlated with Age and 5 other fields | High correlation |
max_power is highly overall correlated with engine and 4 other fields | High correlation |
seats is highly overall correlated with engine | High correlation |
selling_price is highly overall correlated with Age and 5 other fields | High correlation |
torque (Nm) is highly overall correlated with RPM and 5 other fields | High correlation |
transmission is highly overall correlated with max_power | High correlation |
year is highly overall correlated with Age and 3 other fields | High correlation |
seller_type is highly imbalanced (67.5%) | Imbalance |
transmission is highly imbalanced (57.2%) | Imbalance |
Reproduction
| Analysis started | 2023-11-23 07:57:07.194573 |
|---|---|
| Analysis finished | 2023-11-23 07:57:24.493045 |
| Duration | 17.3 seconds |
| Software version | ydata-profiling vv4.6.2 |
| Download configuration | config.json |
name
Text
| Distinct | 1820 |
|---|---|
| Distinct (%) | 28.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 561.2 KiB |
Length
| Max length | 54 |
|---|---|
| Median length | 42 |
| Mean length | 25.251099 |
| Min length | 11 |
Characters and Unicode
| Total characters | 160799 |
|---|---|
| Distinct characters | 68 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 798 ? |
|---|---|
| Unique (%) | 12.5% |
Sample
| 1st row | Maruti Swift Dzire VDI |
|---|---|
| 2nd row | Skoda Rapid 1.5 TDI Ambition |
| 3rd row | Hyundai i20 Sportz Diesel |
| 4th row | Hyundai Xcent 1.2 VTVT E Plus |
| 5th row | Maruti 800 DX BSII |
| Value | Count | Frequency (%) |
| maruti | 2047 | 6.8% |
| hyundai | 1117 | 3.7% |
| mahindra | 692 | 2.3% |
| swift | 606 | 2.0% |
| tata | 562 | 1.9% |
| bsiv | 536 | 1.8% |
| diesel | 534 | 1.8% |
| 1.2 | 480 | 1.6% |
| plus | 473 | 1.6% |
| vxi | 464 | 1.5% |
| Other values (768) | 22591 |
Most occurring characters
| Value | Count | Frequency (%) |
| 23735 | 14.8% | |
| a | 11752 | 7.3% |
| i | 10755 | 6.7% |
| t | 8160 | 5.1% |
| r | 7188 | 4.5% |
| o | 6376 | 4.0% |
| n | 6070 | 3.8% |
| e | 6001 | 3.7% |
| u | 4791 | 3.0% |
| S | 4220 | 2.6% |
| Other values (58) | 71751 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 82198 | |
| Uppercase Letter | 40970 | |
| Space Separator | 23735 | 14.8% |
| Decimal Number | 10887 | 6.8% |
| Other Punctuation | 2017 | 1.3% |
| Dash Punctuation | 576 | 0.4% |
| Close Punctuation | 208 | 0.1% |
| Open Punctuation | 208 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 11752 | |
| i | 10755 | |
| t | 8160 | |
| r | 7188 | |
| o | 6376 | |
| n | 6070 | |
| e | 6001 | |
| u | 4791 | 5.8% |
| d | 3480 | 4.2% |
| l | 3396 | 4.1% |
| Other values (16) | 14229 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4220 | 10.3% |
| I | 3763 | 9.2% |
| M | 3606 | 8.8% |
| D | 3331 | 8.1% |
| V | 3257 | 7.9% |
| T | 3034 | 7.4% |
| X | 2623 | 6.4% |
| C | 1972 | 4.8% |
| A | 1759 | 4.3% |
| H | 1691 | 4.1% |
| Other values (16) | 11714 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2845 | |
| 0 | 2683 | |
| 2 | 2152 | |
| 5 | 833 | 7.7% |
| 4 | 676 | 6.2% |
| 8 | 578 | 5.3% |
| 6 | 340 | 3.1% |
| 3 | 275 | 2.5% |
| 7 | 269 | 2.5% |
| 9 | 236 | 2.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2010 | |
| / | 7 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 23735 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 576 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 208 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 208 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 123168 | |
| Common | 37631 | 23.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 11752 | 9.5% |
| i | 10755 | 8.7% |
| t | 8160 | 6.6% |
| r | 7188 | 5.8% |
| o | 6376 | 5.2% |
| n | 6070 | 4.9% |
| e | 6001 | 4.9% |
| u | 4791 | 3.9% |
| S | 4220 | 3.4% |
| I | 3763 | 3.1% |
| Other values (42) | 54092 |
Common
| Value | Count | Frequency (%) |
| 23735 | ||
| 1 | 2845 | 7.6% |
| 0 | 2683 | 7.1% |
| 2 | 2152 | 5.7% |
| . | 2010 | 5.3% |
| 5 | 833 | 2.2% |
| 4 | 676 | 1.8% |
| 8 | 578 | 1.5% |
| - | 576 | 1.5% |
| 6 | 340 | 0.9% |
| Other values (6) | 1203 | 3.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 160799 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 23735 | 14.8% | |
| a | 11752 | 7.3% |
| i | 10755 | 6.7% |
| t | 8160 | 5.1% |
| r | 7188 | 4.5% |
| o | 6376 | 4.0% |
| n | 6070 | 3.8% |
| e | 6001 | 3.7% |
| u | 4791 | 3.0% |
| S | 4220 | 2.6% |
| Other values (58) | 71751 |
year
Real number (ℝ)
HIGH CORRELATION
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.9001 |
| Minimum | 1994 |
|---|---|
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 1994 |
|---|---|
| 5-th percentile | 2007 |
| Q1 | 2012 |
| median | 2014 |
| Q3 | 2017 |
| 95-th percentile | 2019 |
| Maximum | 2020 |
| Range | 26 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.7372154 |
|---|---|
| Coefficient of variation (CV) | 0.0018557104 |
| Kurtosis | 1.8699148 |
| Mean | 2013.9001 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -1.0704692 |
| Sum | 12824516 |
| Variance | 13.966779 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=27)
| Value | Count | Frequency (%) |
| 2017 | 800 | |
| 2016 | 689 | |
| 2015 | 677 | |
| 2018 | 605 | |
| 2014 | 576 | |
| 2012 | 562 | |
| 2013 | 554 | |
| 2011 | 504 | |
| 2019 | 346 | |
| 2010 | 321 | |
| Other values (17) | 734 |
| Value | Count | Frequency (%) |
| 1994 | 2 | < 0.1% |
| 1995 | 1 | < 0.1% |
| 1996 | 2 | < 0.1% |
| 1997 | 9 | 0.1% |
| 1998 | 9 | 0.1% |
| 1999 | 11 | 0.2% |
| 2000 | 12 | 0.2% |
| 2001 | 6 | 0.1% |
| 2002 | 17 | |
| 2003 | 31 |
| Value | Count | Frequency (%) |
| 2020 | 62 | 1.0% |
| 2019 | 346 | |
| 2018 | 605 | |
| 2017 | 800 | |
| 2016 | 689 | |
| 2015 | 677 | |
| 2014 | 576 | |
| 2013 | 554 | |
| 2012 | 562 | |
| 2011 | 504 |
selling_price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 655 |
|---|---|
| Distinct (%) | 10.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 541845.58 |
| Minimum | 29999 |
|---|---|
| Maximum | 10000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 29999 |
|---|---|
| 5-th percentile | 120000 |
| Q1 | 270000 |
| median | 438999 |
| Q3 | 650000 |
| 95-th percentile | 1216500 |
| Maximum | 10000000 |
| Range | 9970001 |
| Interquartile range (IQR) | 380000 |
Descriptive statistics
| Standard deviation | 528647.17 |
|---|---|
| Coefficient of variation (CV) | 0.97564175 |
| Kurtosis | 52.431818 |
| Mean | 541845.58 |
| Median Absolute Deviation (MAD) | 188999 |
| Skewness | 5.5908793 |
| Sum | 3.4504727 × 109 |
| Variance | 2.7946783 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 300000 | 199 | 3.1% |
| 350000 | 189 | 3.0% |
| 600000 | 165 | 2.6% |
| 400000 | 162 | 2.5% |
| 550000 | 160 | 2.5% |
| 500000 | 159 | 2.5% |
| 450000 | 147 | 2.3% |
| 250000 | 146 | 2.3% |
| 650000 | 143 | 2.2% |
| 700000 | 129 | 2.0% |
| Other values (645) | 4769 |
| Value | Count | Frequency (%) |
| 29999 | 1 | < 0.1% |
| 30000 | 1 | < 0.1% |
| 31000 | 1 | < 0.1% |
| 31504 | 1 | < 0.1% |
| 33351 | 1 | < 0.1% |
| 35000 | 3 | < 0.1% |
| 39000 | 1 | < 0.1% |
| 40000 | 11 | |
| 42000 | 2 | < 0.1% |
| 45000 | 19 |
| Value | Count | Frequency (%) |
| 10000000 | 1 | < 0.1% |
| 7200000 | 1 | < 0.1% |
| 6523000 | 1 | < 0.1% |
| 6223000 | 1 | < 0.1% |
| 6000000 | 3 | |
| 5923000 | 1 | < 0.1% |
| 5850000 | 1 | < 0.1% |
| 5830000 | 1 | < 0.1% |
| 5800000 | 2 | |
| 5500000 | 4 |
km_driven
Real number (ℝ)
HIGH CORRELATION
| Distinct | 869 |
|---|---|
| Distinct (%) | 13.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71829.13 |
| Minimum | 1 |
|---|---|
| Maximum | 2360457 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10070 |
| Q1 | 35000 |
| median | 64650 |
| Q3 | 100000 |
| 95-th percentile | 152000 |
| Maximum | 2360457 |
| Range | 2360456 |
| Interquartile range (IQR) | 65000 |
Descriptive statistics
| Standard deviation | 58964.991 |
|---|---|
| Coefficient of variation (CV) | 0.82090638 |
| Kurtosis | 412.95674 |
| Mean | 71829.13 |
| Median Absolute Deviation (MAD) | 29650 |
| Skewness | 12.401653 |
| Sum | 4.574079 × 108 |
| Variance | 3.4768702 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 120000 | 424 | 6.7% |
| 70000 | 403 | 6.3% |
| 80000 | 380 | 6.0% |
| 60000 | 364 | 5.7% |
| 50000 | 335 | 5.3% |
| 90000 | 280 | 4.4% |
| 100000 | 274 | 4.3% |
| 40000 | 273 | 4.3% |
| 110000 | 217 | 3.4% |
| 30000 | 212 | 3.3% |
| Other values (859) | 3206 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 1000 | 5 | |
| 1300 | 1 | < 0.1% |
| 1303 | 1 | < 0.1% |
| 1500 | 2 | < 0.1% |
| 1600 | 1 | < 0.1% |
| 1620 | 1 | < 0.1% |
| 2000 | 7 | |
| 2118 | 1 | < 0.1% |
| 2136 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2360457 | 1 | |
| 1500000 | 1 | |
| 577414 | 1 | |
| 500000 | 2 | |
| 475000 | 1 | |
| 440000 | 1 | |
| 426000 | 1 | |
| 380000 | 1 | |
| 376412 | 1 | |
| 375000 | 1 |
fuel
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.4 KiB |
| Diesel | |
|---|---|
| Petrol | |
| CNG | 50 |
| LPG | 27 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.9637249 |
| Min length | 3 |
Characters and Unicode
| Total characters | 37977 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Diesel |
|---|---|
| 2nd row | Diesel |
| 3rd row | Diesel |
| 4th row | Petrol |
| 5th row | Petrol |
Common Values
| Value | Count | Frequency (%) |
| Diesel | 3493 | |
| Petrol | 2798 | |
| CNG | 50 | 0.8% |
| LPG | 27 | 0.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| diesel | 3493 | |
| petrol | 2798 | |
| cng | 50 | 0.8% |
| lpg | 27 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9784 | |
| l | 6291 | |
| D | 3493 | 9.2% |
| i | 3493 | 9.2% |
| s | 3493 | 9.2% |
| P | 2825 | 7.4% |
| t | 2798 | 7.4% |
| r | 2798 | 7.4% |
| o | 2798 | 7.4% |
| G | 77 | 0.2% |
| Other values (3) | 127 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 31455 | |
| Uppercase Letter | 6522 | 17.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 9784 | |
| l | 6291 | |
| i | 3493 | 11.1% |
| s | 3493 | 11.1% |
| t | 2798 | 8.9% |
| r | 2798 | 8.9% |
| o | 2798 | 8.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 3493 | |
| P | 2825 | |
| G | 77 | 1.2% |
| C | 50 | 0.8% |
| N | 50 | 0.8% |
| L | 27 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 37977 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 9784 | |
| l | 6291 | |
| D | 3493 | 9.2% |
| i | 3493 | 9.2% |
| s | 3493 | 9.2% |
| P | 2825 | 7.4% |
| t | 2798 | 7.4% |
| r | 2798 | 7.4% |
| o | 2798 | 7.4% |
| G | 77 | 0.2% |
| Other values (3) | 127 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 37977 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 9784 | |
| l | 6291 | |
| D | 3493 | 9.2% |
| i | 3493 | 9.2% |
| s | 3493 | 9.2% |
| P | 2825 | 7.4% |
| t | 2798 | 7.4% |
| r | 2798 | 7.4% |
| o | 2798 | 7.4% |
| G | 77 | 0.2% |
| Other values (3) | 127 | 0.3% |
seller_type
Categorical
IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.3 KiB |
| Individual | |
|---|---|
| Dealer | |
| Trustmark Dealer | 27 |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 9.6165201 |
| Min length | 6 |
Characters and Unicode
| Total characters | 61238 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Individual |
|---|---|
| 2nd row | Individual |
| 3rd row | Individual |
| 4th row | Individual |
| 5th row | Individual |
Common Values
| Value | Count | Frequency (%) |
| Individual | 5690 | |
| Dealer | 651 | 10.2% |
| Trustmark Dealer | 27 | 0.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| individual | 5690 | |
| dealer | 678 | 10.6% |
| trustmark | 27 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 11380 | |
| i | 11380 | |
| a | 6395 | |
| l | 6368 | |
| u | 5717 | |
| I | 5690 | |
| v | 5690 | |
| n | 5690 | |
| e | 1356 | 2.2% |
| r | 732 | 1.2% |
| Other values (7) | 840 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 54816 | |
| Uppercase Letter | 6395 | 10.4% |
| Space Separator | 27 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 11380 | |
| i | 11380 | |
| a | 6395 | |
| l | 6368 | |
| u | 5717 | |
| v | 5690 | |
| n | 5690 | |
| e | 1356 | 2.5% |
| r | 732 | 1.3% |
| s | 27 | < 0.1% |
| Other values (3) | 81 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 5690 | |
| D | 678 | 10.6% |
| T | 27 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 27 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 61211 | |
| Common | 27 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| d | 11380 | |
| i | 11380 | |
| a | 6395 | |
| l | 6368 | |
| u | 5717 | |
| I | 5690 | |
| v | 5690 | |
| n | 5690 | |
| e | 1356 | 2.2% |
| r | 732 | 1.2% |
| Other values (6) | 813 | 1.3% |
Common
| Value | Count | Frequency (%) |
| 27 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 61238 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| d | 11380 | |
| i | 11380 | |
| a | 6395 | |
| l | 6368 | |
| u | 5717 | |
| I | 5690 | |
| v | 5690 | |
| n | 5690 | |
| e | 1356 | 2.2% |
| r | 732 | 1.2% |
| Other values (7) | 840 | 1.4% |
transmission
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.2 KiB |
| Manual | |
|---|---|
| Automatic | 557 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.2624058 |
| Min length | 6 |
Characters and Unicode
| Total characters | 39879 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Manual |
|---|---|
| 2nd row | Manual |
| 3rd row | Manual |
| 4th row | Manual |
| 5th row | Manual |
Common Values
| Value | Count | Frequency (%) |
| Manual | 5811 | |
| Automatic | 557 | 8.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| manual | 5811 | |
| automatic | 557 | 8.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12179 | |
| u | 6368 | |
| M | 5811 | |
| n | 5811 | |
| l | 5811 | |
| t | 1114 | 2.8% |
| A | 557 | 1.4% |
| o | 557 | 1.4% |
| m | 557 | 1.4% |
| i | 557 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 33511 | |
| Uppercase Letter | 6368 | 16.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 12179 | |
| u | 6368 | |
| n | 5811 | |
| l | 5811 | |
| t | 1114 | 3.3% |
| o | 557 | 1.7% |
| m | 557 | 1.7% |
| i | 557 | 1.7% |
| c | 557 | 1.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 5811 | |
| A | 557 | 8.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 39879 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 12179 | |
| u | 6368 | |
| M | 5811 | |
| n | 5811 | |
| l | 5811 | |
| t | 1114 | 2.8% |
| A | 557 | 1.4% |
| o | 557 | 1.4% |
| m | 557 | 1.4% |
| i | 557 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 39879 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 12179 | |
| u | 6368 | |
| M | 5811 | |
| n | 5811 | |
| l | 5811 | |
| t | 1114 | 2.8% |
| A | 557 | 1.4% |
| o | 557 | 1.4% |
| m | 557 | 1.4% |
| i | 557 | 1.4% |
owner
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.5 KiB |
| First Owner | |
|---|---|
| Second Owner | |
| Third Owner | |
| Fourth & Above Owner | 133 |
| Test Drive Car | 5 |
Length
| Max length | 20 |
|---|---|
| Median length | 11 |
| Mean length | 11.462783 |
| Min length | 11 |
Characters and Unicode
| Total characters | 72995 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | First Owner |
|---|---|
| 2nd row | Second Owner |
| 3rd row | First Owner |
| 4th row | First Owner |
| 5th row | Second Owner |
Common Values
| Value | Count | Frequency (%) |
| First Owner | 4075 | |
| Second Owner | 1735 | |
| Third Owner | 420 | 6.6% |
| Fourth & Above Owner | 133 | 2.1% |
| Test Drive Car | 5 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| owner | 6363 | |
| first | 4075 | |
| second | 1735 | 13.3% |
| third | 420 | 3.2% |
| fourth | 133 | 1.0% |
| 133 | 1.0% | |
| above | 133 | 1.0% |
| test | 5 | < 0.1% |
| drive | 5 | < 0.1% |
| car | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 11001 | |
| e | 8241 | |
| n | 8098 | |
| 6639 | ||
| O | 6363 | |
| w | 6363 | |
| i | 4500 | |
| t | 4213 | 5.8% |
| F | 4208 | 5.8% |
| s | 4080 | 5.6% |
| Other values (14) | 9289 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 53349 | |
| Uppercase Letter | 12874 | 17.6% |
| Space Separator | 6639 | 9.1% |
| Other Punctuation | 133 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 11001 | |
| e | 8241 | |
| n | 8098 | |
| w | 6363 | |
| i | 4500 | |
| t | 4213 | 7.9% |
| s | 4080 | 7.6% |
| d | 2155 | 4.0% |
| o | 2001 | 3.8% |
| c | 1735 | 3.3% |
| Other values (5) | 962 | 1.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 6363 | |
| F | 4208 | |
| S | 1735 | 13.5% |
| T | 425 | 3.3% |
| A | 133 | 1.0% |
| D | 5 | < 0.1% |
| C | 5 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 6639 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 133 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 66223 | |
| Common | 6772 | 9.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 11001 | |
| e | 8241 | |
| n | 8098 | |
| O | 6363 | |
| w | 6363 | |
| i | 4500 | |
| t | 4213 | 6.4% |
| F | 4208 | 6.4% |
| s | 4080 | 6.2% |
| d | 2155 | 3.3% |
| Other values (12) | 7001 |
Common
| Value | Count | Frequency (%) |
| 6639 | ||
| & | 133 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72995 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 11001 | |
| e | 8241 | |
| n | 8098 | |
| 6639 | ||
| O | 6363 | |
| w | 6363 | |
| i | 4500 | |
| t | 4213 | 5.8% |
| F | 4208 | 5.8% |
| s | 4080 | 5.6% |
| Other values (14) | 9289 |
torque (Nm)
Real number (ℝ)
HIGH CORRELATION
| Distinct | 203 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.90744 |
| Minimum | 14.9 |
|---|---|
| Maximum | 3724 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 14.9 |
|---|---|
| 5-th percentile | 62 |
| Q1 | 110 |
| median | 170 |
| Q3 | 200 |
| 95-th percentile | 330 |
| Maximum | 3724 |
| Range | 3709.1 |
| Interquartile range (IQR) | 90 |
Descriptive statistics
| Standard deviation | 100.88477 |
|---|---|
| Coefficient of variation (CV) | 0.5834611 |
| Kurtosis | 251.73348 |
| Mean | 172.90744 |
| Median Absolute Deviation (MAD) | 56.225 |
| Skewness | 8.5628549 |
| Sum | 1101074.6 |
| Variance | 10177.736 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 200 | 593 | 9.3% |
| 190 | 548 | 8.6% |
| 90 | 355 | 5.6% |
| 114 | 227 | 3.6% |
| 113 | 171 | 2.7% |
| 62 | 161 | 2.5% |
| 160 | 156 | 2.4% |
| 69 | 131 | 2.1% |
| 250 | 129 | 2.0% |
| 330 | 121 | 1.9% |
| Other values (193) | 3776 |
| Value | Count | Frequency (%) |
| 14.9 | 3 | < 0.1% |
| 24 | 10 | 0.2% |
| 47.04 | 1 | < 0.1% |
| 48 | 6 | 0.1% |
| 51 | 18 | 0.3% |
| 57 | 2 | < 0.1% |
| 59 | 107 | |
| 59.78 | 11 | 0.2% |
| 60 | 2 | < 0.1% |
| 62 | 161 |
| Value | Count | Frequency (%) |
| 3724 | 1 | < 0.1% |
| 1274 | 4 | |
| 1127 | 1 | < 0.1% |
| 789 | 3 | |
| 640 | 1 | < 0.1% |
| 620 | 6 | |
| 619 | 3 | |
| 600 | 3 | |
| 580 | 2 | < 0.1% |
| 560 | 2 | < 0.1% |
RPM
Real number (ℝ)
HIGH CORRELATION
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3037.7164 |
| Minimum | 400 |
|---|---|
| Maximum | 5300 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 400 |
|---|---|
| 5-th percentile | 1750 |
| Q1 | 2250 |
| median | 3000 |
| Q3 | 4000 |
| 95-th percentile | 4500 |
| Maximum | 5300 |
| Range | 4900 |
| Interquartile range (IQR) | 1750 |
Descriptive statistics
| Standard deviation | 901.20446 |
|---|---|
| Coefficient of variation (CV) | 0.29667169 |
| Kurtosis | -0.98698803 |
| Mean | 3037.7164 |
| Median Absolute Deviation (MAD) | 800 |
| Skewness | 0.11390448 |
| Sum | 19344178 |
| Variance | 812169.49 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=49)
| Value | Count | Frequency (%) |
| 4000 | 840 | |
| 2000 | 738 | |
| 3500 | 668 | |
| 3000 | 555 | 8.7% |
| 1750 | 509 | 8.0% |
| 2500 | 483 | 7.6% |
| 2750 | 398 | 6.2% |
| 2800 | 371 | 5.8% |
| 4200 | 208 | 3.3% |
| 4500 | 192 | 3.0% |
| Other values (39) | 1406 |
| Value | Count | Frequency (%) |
| 400 | 3 | < 0.1% |
| 480 | 1 | < 0.1% |
| 500 | 14 | 0.2% |
| 1400 | 2 | < 0.1% |
| 1500 | 77 | 1.2% |
| 1600 | 1 | < 0.1% |
| 1740 | 1 | < 0.1% |
| 1750 | 509 | |
| 1800 | 26 | 0.4% |
| 1850 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5300 | 1 | < 0.1% |
| 5200 | 1 | < 0.1% |
| 5000 | 26 | 0.4% |
| 4850 | 23 | 0.4% |
| 4800 | 80 | |
| 4750 | 8 | 0.1% |
| 4700 | 8 | 0.1% |
| 4600 | 58 | 0.9% |
| 4500 | 192 | |
| 4400 | 63 | 1.0% |
mileage
Real number (ℝ)
| Distinct | 373 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.693841 |
| Minimum | 9 |
|---|---|
| Maximum | 42 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 12.99 |
| Q1 | 17 |
| median | 19.7 |
| Q3 | 22.7 |
| 95-th percentile | 25.83 |
| Maximum | 42 |
| Range | 33 |
| Interquartile range (IQR) | 5.7 |
Descriptive statistics
| Standard deviation | 3.9388093 |
|---|---|
| Coefficient of variation (CV) | 0.20000209 |
| Kurtosis | -0.29131507 |
| Mean | 19.693841 |
| Median Absolute Deviation (MAD) | 2.84 |
| Skewness | -0.0065653159 |
| Sum | 125410.38 |
| Variance | 15.514219 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18.9 | 210 | 3.3% |
| 19.7 | 167 | 2.6% |
| 18.6 | 150 | 2.4% |
| 21.1 | 147 | 2.3% |
| 15.96 | 108 | 1.7% |
| 17 | 91 | 1.4% |
| 16.1 | 87 | 1.4% |
| 15.1 | 86 | 1.4% |
| 28.4 | 85 | 1.3% |
| 12.8 | 85 | 1.3% |
| Other values (363) | 5152 |
| Value | Count | Frequency (%) |
| 9 | 4 | 0.1% |
| 9.5 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 10.1 | 2 | < 0.1% |
| 10.5 | 17 | |
| 10.75 | 2 | < 0.1% |
| 10.8 | 1 | < 0.1% |
| 10.9 | 2 | < 0.1% |
| 10.91 | 4 | 0.1% |
| 10.93 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 42 | 1 | < 0.1% |
| 33.44 | 2 | < 0.1% |
| 33 | 1 | < 0.1% |
| 32.52 | 1 | < 0.1% |
| 32.26 | 1 | < 0.1% |
| 30.46 | 2 | < 0.1% |
| 28.4 | 85 | |
| 28.09 | 31 | 0.5% |
| 27.62 | 6 | 0.1% |
| 27.4 | 4 | 0.1% |
engine
Real number (ℝ)
HIGH CORRELATION
| Distinct | 115 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1424.7778 |
| Minimum | 624 |
|---|---|
| Maximum | 3604 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 74.6 KiB |
Quantile statistics
| Minimum | 624 |
|---|---|
| 5-th percentile | 796 |
| Q1 | 1196 |
| median | 1248 |
| Q3 | 1498 |
| 95-th percentile | 2499 |
| Maximum | 3604 |
| Range | 2980 |
| Interquartile range (IQR) | 302 |
Descriptive statistics
| Standard deviation | 496.68164 |
|---|---|
| Coefficient of variation (CV) | 0.34860288 |
| Kurtosis | 0.95731673 |
| Mean | 1424.7778 |
| Median Absolute Deviation (MAD) | 245 |
| Skewness | 1.2229212 |
| Sum | 9072985 |
| Variance | 246692.65 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1248 | 907 | 14.2% |
| 1197 | 662 | 10.4% |
| 796 | 417 | 6.5% |
| 998 | 398 | 6.2% |
| 1498 | 336 | 5.3% |
| 2179 | 336 | 5.3% |
| 1396 | 263 | 4.1% |
| 1199 | 192 | 3.0% |
| 2523 | 181 | 2.8% |
| 1198 | 163 | 2.6% |
| Other values (105) | 2513 |
| Value | Count | Frequency (%) |
| 624 | 25 | 0.4% |
| 793 | 6 | 0.1% |
| 796 | 417 | |
| 799 | 71 | 1.1% |
| 814 | 111 | 1.7% |
| 909 | 2 | < 0.1% |
| 936 | 34 | 0.5% |
| 993 | 26 | 0.4% |
| 995 | 41 | 0.6% |
| 998 | 398 |
| Value | Count | Frequency (%) |
| 3604 | 1 | < 0.1% |
| 3498 | 1 | < 0.1% |
| 3198 | 4 | 0.1% |
| 2999 | 2 | < 0.1% |
| 2997 | 2 | < 0.1% |
| 2993 | 11 | |
| 2987 | 6 | 0.1% |
| 2982 | 27 | |
| 2967 | 8 | 0.1% |
| 2956 | 18 |
max_power
Real number (ℝ)
HIGH CORRELATION
| Distinct | 299 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 87.858856 |
| Minimum | 32.8 |
|---|---|
| Maximum | 400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 32.8 |
|---|---|
| 5-th percentile | 47.3 |
| Q1 | 67.1 |
| median | 81.86 |
| Q3 | 100 |
| 95-th percentile | 147.9 |
| Maximum | 400 |
| Range | 367.2 |
| Interquartile range (IQR) | 32.9 |
Descriptive statistics
| Standard deviation | 31.90044 |
|---|---|
| Coefficient of variation (CV) | 0.36308736 |
| Kurtosis | 5.4044068 |
| Mean | 87.858856 |
| Median Absolute Deviation (MAD) | 14.82 |
| Skewness | 1.7004913 |
| Sum | 559485.19 |
| Variance | 1017.6381 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 74 | 324 | 5.1% |
| 88.5 | 193 | 3.0% |
| 46.3 | 158 | 2.5% |
| 67 | 152 | 2.4% |
| 67.1 | 141 | 2.2% |
| 81.8 | 136 | 2.1% |
| 67.04 | 136 | 2.1% |
| 47.3 | 131 | 2.1% |
| 62.1 | 128 | 2.0% |
| 120 | 124 | 1.9% |
| Other values (289) | 4745 |
| Value | Count | Frequency (%) |
| 32.8 | 2 | < 0.1% |
| 34.2 | 20 | 0.3% |
| 35 | 18 | 0.3% |
| 35.5 | 1 | < 0.1% |
| 37 | 88 | |
| 37.48 | 11 | 0.2% |
| 37.5 | 5 | 0.1% |
| 38 | 2 | < 0.1% |
| 38.4 | 2 | < 0.1% |
| 40.3 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 400 | 1 | < 0.1% |
| 282 | 1 | < 0.1% |
| 280 | 1 | < 0.1% |
| 272 | 1 | < 0.1% |
| 270.9 | 3 | |
| 265 | 1 | < 0.1% |
| 261.4 | 4 | |
| 258 | 2 | |
| 254.8 | 3 | |
| 254.79 | 1 | < 0.1% |
seats
Real number (ℝ)
HIGH CORRELATION
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.4356156 |
| Minimum | 4 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 9 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.95932696 |
|---|---|
| Coefficient of variation (CV) | 0.17648911 |
| Kurtosis | 2.0184366 |
| Mean | 5.4356156 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.7257737 |
| Sum | 34614 |
| Variance | 0.92030821 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 5 | 4944 | |
| 7 | 958 | 15.0% |
| 8 | 215 | 3.4% |
| 4 | 124 | 1.9% |
| 9 | 70 | 1.1% |
| 6 | 57 | 0.9% |
| Value | Count | Frequency (%) |
| 4 | 124 | 1.9% |
| 5 | 4944 | |
| 6 | 57 | 0.9% |
| 7 | 958 | 15.0% |
| 8 | 215 | 3.4% |
| 9 | 70 | 1.1% |
| Value | Count | Frequency (%) |
| 9 | 70 | 1.1% |
| 8 | 215 | 3.4% |
| 7 | 958 | 15.0% |
| 6 | 57 | 0.9% |
| 5 | 4944 | |
| 4 | 124 | 1.9% |
Brand
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 443.3 KiB |
| Maruti | |
|---|---|
| Hyundai | |
| Mahindra | |
| Tata | |
| Honda | |
| Other values (26) |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 6.276696 |
| Min length | 2 |
Characters and Unicode
| Total characters | 39970 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Maruti |
|---|---|
| 2nd row | Skoda |
| 3rd row | Hyundai |
| 4th row | Hyundai |
| 5th row | Maruti |
Common Values
| Value | Count | Frequency (%) |
| Maruti | 2047 | |
| Hyundai | 1117 | |
| Mahindra | 692 | 10.9% |
| Tata | 562 | 8.8% |
| Honda | 330 | 5.2% |
| Ford | 319 | 5.0% |
| Toyota | 316 | 5.0% |
| Renault | 206 | 3.2% |
| Chevrolet | 197 | 3.1% |
| Volkswagen | 166 | 2.6% |
| Other values (21) | 416 | 6.5% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| maruti | 2047 | |
| hyundai | 1117 | |
| mahindra | 692 | 10.9% |
| tata | 562 | 8.8% |
| honda | 330 | 5.2% |
| ford | 319 | 5.0% |
| toyota | 316 | 5.0% |
| renault | 206 | 3.2% |
| chevrolet | 197 | 3.1% |
| volkswagen | 166 | 2.6% |
| Other values (21) | 416 | 6.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6954 | |
| i | 4021 | |
| u | 3482 | |
| t | 3430 | |
| r | 3310 | |
| M | 2829 | 7.1% |
| n | 2682 | 6.7% |
| d | 2598 | 6.5% |
| o | 1740 | 4.4% |
| H | 1447 | 3.6% |
| Other values (33) | 7477 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 33437 | |
| Uppercase Letter | 6494 | 16.2% |
| Dash Punctuation | 39 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6954 | |
| i | 4021 | |
| u | 3482 | |
| t | 3430 | |
| r | 3310 | |
| n | 2682 | 8.0% |
| d | 2598 | 7.8% |
| o | 1740 | 5.2% |
| y | 1433 | 4.3% |
| e | 975 | 2.9% |
| Other values (13) | 2812 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 2829 | |
| H | 1447 | |
| T | 878 | 13.5% |
| F | 362 | 5.6% |
| R | 206 | 3.2% |
| C | 197 | 3.0% |
| V | 175 | 2.7% |
| B | 81 | 1.2% |
| N | 73 | 1.1% |
| S | 63 | 1.0% |
| Other values (9) | 183 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 39 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 39931 | |
| Common | 39 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6954 | |
| i | 4021 | |
| u | 3482 | |
| t | 3430 | |
| r | 3310 | |
| M | 2829 | 7.1% |
| n | 2682 | 6.7% |
| d | 2598 | 6.5% |
| o | 1740 | 4.4% |
| H | 1447 | 3.6% |
| Other values (32) | 7438 |
Common
| Value | Count | Frequency (%) |
| - | 39 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 39970 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 6954 | |
| i | 4021 | |
| u | 3482 | |
| t | 3430 | |
| r | 3310 | |
| M | 2829 | 7.1% |
| n | 2682 | 6.7% |
| d | 2598 | 6.5% |
| o | 1740 | 4.4% |
| H | 1447 | 3.6% |
| Other values (33) | 7477 |
Model
Text
| Distinct | 1820 |
|---|---|
| Distinct (%) | 28.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 516.0 KiB |
Length
| Max length | 45 |
|---|---|
| Median length | 36 |
| Mean length | 17.974246 |
| Min length | 4 |
Characters and Unicode
| Total characters | 114460 |
|---|---|
| Distinct characters | 68 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 798 ? |
|---|---|
| Unique (%) | 12.5% |
Sample
| 1st row | Swift Dzire VDI |
|---|---|
| 2nd row | Rapid 1.5 TDI Ambition |
| 3rd row | i20 Sportz Diesel |
| 4th row | Xcent 1.2 VTVT E Plus |
| 5th row | 800 DX BSII |
| Value | Count | Frequency (%) |
| swift | 606 | 2.6% |
| bsiv | 536 | 2.3% |
| diesel | 534 | 2.2% |
| 1.2 | 480 | 2.0% |
| plus | 473 | 2.0% |
| vxi | 464 | 2.0% |
| vdi | 443 | 1.9% |
| alto | 394 | 1.7% |
| lxi | 384 | 1.6% |
| dzire | 349 | 1.5% |
| Other values (738) | 19071 |
Most occurring characters
| Value | Count | Frequency (%) |
| 17366 | 15.2% | |
| i | 6734 | 5.9% |
| e | 5026 | 4.4% |
| a | 4798 | 4.2% |
| t | 4730 | 4.1% |
| o | 4636 | 4.1% |
| S | 4157 | 3.6% |
| r | 3878 | 3.4% |
| I | 3759 | 3.3% |
| n | 3388 | 3.0% |
| Other values (58) | 55988 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 48761 | |
| Uppercase Letter | 34476 | |
| Space Separator | 17366 | 15.2% |
| Decimal Number | 10887 | 9.5% |
| Other Punctuation | 2017 | 1.8% |
| Dash Punctuation | 537 | 0.5% |
| Open Punctuation | 208 | 0.2% |
| Close Punctuation | 208 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 6734 | |
| e | 5026 | |
| a | 4798 | |
| t | 4730 | |
| o | 4636 | |
| r | 3878 | |
| n | 3388 | 6.9% |
| l | 2817 | 5.8% |
| s | 2089 | 4.3% |
| u | 1309 | 2.7% |
| Other values (16) | 9356 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4157 | |
| I | 3759 | |
| D | 3271 | 9.5% |
| V | 3082 | 8.9% |
| X | 2623 | 7.6% |
| T | 2156 | 6.3% |
| C | 1775 | 5.1% |
| A | 1722 | 5.0% |
| B | 1561 | 4.5% |
| L | 1555 | 4.5% |
| Other values (16) | 8815 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2845 | |
| 0 | 2683 | |
| 2 | 2152 | |
| 5 | 833 | 7.7% |
| 4 | 676 | 6.2% |
| 8 | 578 | 5.3% |
| 6 | 340 | 3.1% |
| 3 | 275 | 2.5% |
| 7 | 269 | 2.5% |
| 9 | 236 | 2.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2010 | |
| / | 7 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 17366 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 537 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 208 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 208 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 83237 | |
| Common | 31223 | 27.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 6734 | 8.1% |
| e | 5026 | 6.0% |
| a | 4798 | 5.8% |
| t | 4730 | 5.7% |
| o | 4636 | 5.6% |
| S | 4157 | 5.0% |
| r | 3878 | 4.7% |
| I | 3759 | 4.5% |
| n | 3388 | 4.1% |
| D | 3271 | 3.9% |
| Other values (42) | 38860 |
Common
| Value | Count | Frequency (%) |
| 17366 | ||
| 1 | 2845 | 9.1% |
| 0 | 2683 | 8.6% |
| 2 | 2152 | 6.9% |
| . | 2010 | 6.4% |
| 5 | 833 | 2.7% |
| 4 | 676 | 2.2% |
| 8 | 578 | 1.9% |
| - | 537 | 1.7% |
| 6 | 340 | 1.1% |
| Other values (6) | 1203 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 114460 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 17366 | 15.2% | |
| i | 6734 | 5.9% |
| e | 5026 | 4.4% |
| a | 4798 | 4.2% |
| t | 4730 | 4.1% |
| o | 4636 | 4.1% |
| S | 4157 | 3.6% |
| r | 3878 | 3.4% |
| I | 3759 | 3.3% |
| n | 3388 | 3.0% |
| Other values (58) | 55988 |
Age
Real number (ℝ)
HIGH CORRELATION
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.0998744 |
| Minimum | 3 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 6 |
| median | 9 |
| Q3 | 11 |
| 95-th percentile | 16 |
| Maximum | 29 |
| Range | 26 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.7372154 |
|---|---|
| Coefficient of variation (CV) | 0.41068868 |
| Kurtosis | 1.8699148 |
| Mean | 9.0998744 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.0704692 |
| Sum | 57948 |
| Variance | 13.966779 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=27)
| Value | Count | Frequency (%) |
| 6 | 800 | |
| 7 | 689 | |
| 8 | 677 | |
| 5 | 605 | |
| 9 | 576 | |
| 11 | 562 | |
| 10 | 554 | |
| 12 | 504 | |
| 4 | 346 | |
| 13 | 321 | |
| Other values (17) | 734 |
| Value | Count | Frequency (%) |
| 3 | 62 | 1.0% |
| 4 | 346 | |
| 5 | 605 | |
| 6 | 800 | |
| 7 | 689 | |
| 8 | 677 | |
| 9 | 576 | |
| 10 | 554 | |
| 11 | 562 | |
| 12 | 504 |
| Value | Count | Frequency (%) |
| 29 | 2 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 2 | < 0.1% |
| 26 | 9 | 0.1% |
| 25 | 9 | 0.1% |
| 24 | 11 | 0.2% |
| 23 | 12 | 0.2% |
| 22 | 6 | 0.1% |
| 21 | 17 | |
| 20 | 31 |
log_sell
Real number (ℝ)
HIGH CORRELATION
| Distinct | 655 |
|---|---|
| Distinct (%) | 10.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.6158829 |
| Minimum | 4.4771068 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 99.5 KiB |
Quantile statistics
| Minimum | 4.4771068 |
|---|---|
| 5-th percentile | 5.0791812 |
| Q1 | 5.4313638 |
| median | 5.6424635 |
| Q3 | 5.8129134 |
| 95-th percentile | 6.0851088 |
| Maximum | 7 |
| Range | 2.5228932 |
| Interquartile range (IQR) | 0.38154959 |
Descriptive statistics
| Standard deviation | 0.31865093 |
|---|---|
| Coefficient of variation (CV) | 0.056741021 |
| Kurtosis | 1.0260492 |
| Mean | 5.6158829 |
| Median Absolute Deviation (MAD) | 0.18684024 |
| Skewness | -0.17686852 |
| Sum | 35761.942 |
| Variance | 0.10153841 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5.477121255 | 199 | 3.1% |
| 5.544068044 | 189 | 3.0% |
| 5.77815125 | 165 | 2.6% |
| 5.602059991 | 162 | 2.5% |
| 5.740362689 | 160 | 2.5% |
| 5.698970004 | 159 | 2.5% |
| 5.653212514 | 147 | 2.3% |
| 5.397940009 | 146 | 2.3% |
| 5.812913357 | 143 | 2.2% |
| 5.84509804 | 129 | 2.0% |
| Other values (645) | 4769 |
| Value | Count | Frequency (%) |
| 4.477106778 | 1 | < 0.1% |
| 4.477121255 | 1 | < 0.1% |
| 4.491361694 | 1 | < 0.1% |
| 4.498365699 | 1 | < 0.1% |
| 4.52310886 | 1 | < 0.1% |
| 4.544068044 | 3 | < 0.1% |
| 4.591064607 | 1 | < 0.1% |
| 4.602059991 | 11 | |
| 4.62324929 | 2 | < 0.1% |
| 4.653212514 | 19 |
| Value | Count | Frequency (%) |
| 7 | 1 | < 0.1% |
| 6.857332496 | 1 | < 0.1% |
| 6.814447379 | 1 | < 0.1% |
| 6.793999801 | 1 | < 0.1% |
| 6.77815125 | 3 | |
| 6.772541733 | 1 | < 0.1% |
| 6.767155866 | 1 | < 0.1% |
| 6.765668555 | 1 | < 0.1% |
| 6.763427994 | 2 | |
| 6.740362689 | 4 |
| Age | Brand | RPM | engine | fuel | km_driven | log_sell | max_power | mileage | owner | seats | seller_type | selling_price | torque (Nm) | transmission | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Age | 1.000 | 0.198 | -0.100 | 0.016 | 0.144 | 0.573 | -0.661 | -0.174 | -0.314 | 0.256 | -0.018 | 0.090 | -0.661 | -0.113 | 0.171 | -1.000 |
| Brand | 0.198 | 1.000 | -0.092 | -0.020 | 0.264 | 0.084 | -0.048 | -0.080 | 0.019 | 0.128 | 0.064 | 0.184 | -0.048 | -0.026 | 0.500 | -0.048 |
| RPM | -0.100 | -0.092 | 1.000 | -0.359 | 0.493 | -0.330 | -0.130 | -0.037 | -0.205 | 0.066 | -0.184 | 0.063 | -0.130 | -0.509 | 0.143 | 0.100 |
| engine | 0.016 | -0.020 | -0.359 | 1.000 | 0.469 | 0.305 | 0.528 | 0.741 | -0.413 | 0.075 | 0.551 | 0.107 | 0.528 | 0.851 | 0.398 | -0.016 |
| fuel | 0.144 | 0.264 | 0.493 | 0.469 | 1.000 | -0.385 | -0.349 | -0.352 | -0.114 | 0.025 | -0.365 | 0.047 | -0.349 | -0.766 | 0.037 | 0.017 |
| km_driven | 0.573 | 0.084 | -0.330 | 0.305 | -0.385 | 1.000 | -0.258 | 0.062 | -0.177 | 0.030 | 0.217 | 0.000 | -0.258 | 0.249 | 0.018 | -0.573 |
| log_sell | -0.661 | -0.048 | -0.130 | 0.528 | -0.349 | -0.258 | 1.000 | 0.658 | -0.028 | 0.275 | 0.323 | 0.178 | 1.000 | 0.629 | 0.492 | 0.661 |
| max_power | -0.174 | -0.080 | -0.037 | 0.741 | -0.352 | 0.062 | 0.658 | 1.000 | -0.320 | 0.084 | 0.332 | 0.154 | 0.658 | 0.797 | 0.511 | 0.174 |
| mileage | -0.314 | 0.019 | -0.205 | -0.413 | -0.114 | -0.177 | -0.028 | -0.320 | 1.000 | 0.081 | -0.461 | 0.031 | -0.028 | -0.160 | 0.242 | 0.314 |
| owner | 0.256 | 0.128 | 0.066 | 0.075 | 0.025 | 0.030 | 0.275 | 0.084 | 0.081 | 1.000 | 0.010 | 0.130 | -0.341 | -0.029 | 0.106 | -0.464 |
| seats | -0.018 | 0.064 | -0.184 | 0.551 | -0.365 | 0.217 | 0.323 | 0.332 | -0.461 | 0.010 | 1.000 | 0.029 | 0.323 | 0.451 | 0.039 | 0.018 |
| seller_type | 0.090 | 0.184 | 0.063 | 0.107 | 0.047 | 0.000 | 0.178 | 0.154 | 0.031 | 0.130 | 0.029 | 1.000 | -0.191 | -0.125 | 0.211 | -0.117 |
| selling_price | -0.661 | -0.048 | -0.130 | 0.528 | -0.349 | -0.258 | 1.000 | 0.658 | -0.028 | -0.341 | 0.323 | -0.191 | 1.000 | 0.629 | 0.463 | 0.661 |
| torque (Nm) | -0.113 | -0.026 | -0.509 | 0.851 | -0.766 | 0.249 | 0.629 | 0.797 | -0.160 | -0.029 | 0.451 | -0.125 | 0.629 | 1.000 | 0.377 | 0.113 |
| transmission | 0.171 | 0.500 | 0.143 | 0.398 | 0.037 | 0.018 | 0.492 | 0.511 | 0.242 | 0.106 | 0.039 | 0.211 | 0.463 | 0.377 | 1.000 | -0.161 |
| year | -1.000 | -0.048 | 0.100 | -0.016 | 0.017 | -0.573 | 0.661 | 0.174 | 0.314 | -0.464 | 0.018 | -0.117 | 0.661 | 0.113 | -0.161 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| name | year | selling_price | km_driven | fuel | seller_type | transmission | owner | torque (Nm) | RPM | mileage | engine | max_power | seats | Brand | Model | Age | log_sell | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Maruti Swift Dzire VDI | 2014 | 450000 | 145500 | Diesel | Individual | Manual | First Owner | 190.00 | 2000.0 | 23.40 | 1248 | 74.00 | 5.0 | Maruti | Swift Dzire VDI | 9 | 5.653213 |
| 1 | Skoda Rapid 1.5 TDI Ambition | 2014 | 370000 | 120000 | Diesel | Individual | Manual | Second Owner | 250.00 | 2500.0 | 21.14 | 1498 | 103.52 | 5.0 | Skoda | Rapid 1.5 TDI Ambition | 9 | 5.568202 |
| 3 | Hyundai i20 Sportz Diesel | 2010 | 225000 | 127000 | Diesel | Individual | Manual | First Owner | 219.52 | 2750.0 | 23.00 | 1396 | 90.00 | 5.0 | Hyundai | i20 Sportz Diesel | 13 | 5.352183 |
| 5 | Hyundai Xcent 1.2 VTVT E Plus | 2017 | 440000 | 45000 | Petrol | Individual | Manual | First Owner | 113.75 | 4000.0 | 20.14 | 1197 | 81.86 | 5.0 | Hyundai | Xcent 1.2 VTVT E Plus | 6 | 5.643453 |
| 7 | Maruti 800 DX BSII | 2001 | 45000 | 5000 | Petrol | Individual | Manual | Second Owner | 59.00 | 2500.0 | 16.10 | 796 | 37.00 | 4.0 | Maruti | 800 DX BSII | 22 | 4.653213 |
| 8 | Toyota Etios VXD | 2011 | 350000 | 90000 | Diesel | Individual | Manual | First Owner | 170.00 | 2400.0 | 23.59 | 1364 | 67.10 | 5.0 | Toyota | Etios VXD | 12 | 5.544068 |
| 9 | Ford Figo Diesel Celebration Edition | 2013 | 200000 | 169000 | Diesel | Individual | Manual | First Owner | 160.00 | 2000.0 | 20.00 | 1399 | 68.10 | 5.0 | Ford | Figo Diesel Celebration Edition | 10 | 5.301030 |
| 10 | Renault Duster 110PS Diesel RxL | 2014 | 500000 | 68000 | Diesel | Individual | Manual | Second Owner | 248.00 | 2250.0 | 19.01 | 1461 | 108.45 | 5.0 | Renault | Duster 110PS Diesel RxL | 9 | 5.698970 |
| 11 | Maruti Zen LX | 2005 | 92000 | 100000 | Petrol | Individual | Manual | Second Owner | 78.00 | 4500.0 | 17.30 | 993 | 60.00 | 5.0 | Maruti | Zen LX | 18 | 4.963788 |
| 12 | Maruti Swift Dzire VDi | 2009 | 280000 | 140000 | Diesel | Individual | Manual | Second Owner | 190.00 | 2000.0 | 19.30 | 1248 | 73.90 | 5.0 | Maruti | Swift Dzire VDi | 14 | 5.447158 |
| name | year | selling_price | km_driven | fuel | seller_type | transmission | owner | torque (Nm) | RPM | mileage | engine | max_power | seats | Brand | Model | Age | log_sell | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8114 | Maruti Alto LXi | 2011 | 200000 | 73000 | Petrol | Individual | Manual | First Owner | 62.0 | 3000.0 | 19.70 | 796 | 46.30 | 5.0 | Maruti | Alto LXi | 12 | 5.301030 |
| 8115 | Maruti 800 AC | 1997 | 40000 | 120000 | Petrol | Individual | Manual | First Owner | 59.0 | 2500.0 | 16.10 | 796 | 37.00 | 4.0 | Maruti | 800 AC | 26 | 4.602060 |
| 8116 | Maruti Alto K10 VXI Airbag | 2017 | 340000 | 45000 | Petrol | Individual | Manual | First Owner | 90.0 | 3500.0 | 23.95 | 998 | 67.10 | 5.0 | Maruti | Alto K10 VXI Airbag | 6 | 5.531479 |
| 8118 | Hyundai i20 Magna | 2013 | 380000 | 25000 | Petrol | Individual | Manual | First Owner | 113.7 | 4000.0 | 18.50 | 1197 | 82.85 | 5.0 | Hyundai | i20 Magna | 10 | 5.579784 |
| 8119 | Maruti Wagon R LXI Optional | 2017 | 360000 | 80000 | Petrol | Individual | Manual | First Owner | 90.0 | 3500.0 | 20.51 | 998 | 67.04 | 5.0 | Maruti | Wagon R LXI Optional | 6 | 5.556303 |
| 8120 | Hyundai Santro Xing GLS | 2008 | 120000 | 191000 | Petrol | Individual | Manual | First Owner | 96.1 | 3000.0 | 17.92 | 1086 | 62.10 | 5.0 | Hyundai | Santro Xing GLS | 15 | 5.079181 |
| 8121 | Maruti Wagon R VXI BS IV with ABS | 2013 | 260000 | 50000 | Petrol | Individual | Manual | Second Owner | 90.0 | 3500.0 | 18.90 | 998 | 67.10 | 5.0 | Maruti | Wagon R VXI BS IV with ABS | 10 | 5.414973 |
| 8122 | Hyundai i20 Magna 1.4 CRDi | 2014 | 475000 | 80000 | Diesel | Individual | Manual | Second Owner | 219.7 | 2750.0 | 22.54 | 1396 | 88.73 | 5.0 | Hyundai | i20 Magna 1.4 CRDi | 9 | 5.676694 |
| 8123 | Hyundai i20 Magna | 2013 | 320000 | 110000 | Petrol | Individual | Manual | First Owner | 113.7 | 4000.0 | 18.50 | 1197 | 82.85 | 5.0 | Hyundai | i20 Magna | 10 | 5.505150 |
| 8125 | Maruti Swift Dzire ZDi | 2009 | 382000 | 120000 | Diesel | Individual | Manual | First Owner | 190.0 | 2000.0 | 19.30 | 1248 | 73.90 | 5.0 | Maruti | Swift Dzire ZDi | 14 | 5.582063 |